SELECT *, CASE WHEN `name` LIKE "isle of palms%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "isle of palms" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "isle of palms" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "isle of palms" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "SC" AND (locality IN ("isle of palms") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 30
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "SC" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 30
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$12,234,60034 Waterway Island DrIsle of Palms SC 29451View Listing
$7,250,00058 Grand Pavilion BlvdIsle of Palms SC 29451View Listing
$5,900,0007 Driftwood LnIsle of Palms SC 29451View Listing
$4,985,0002 3/4 Tabby LnIsle of Palms SC 29451View Listing
$4,695,00010 54th AveIsle of Palms SC 29451View Listing
$4,500,000112 Palm BlvdIsle of Palms SC 29451View Listing
$4,095,0009 13th AveIsle of Palms SC 29451View Listing
$3,995,0004 29th AveIsle of Palms SC 29451View Listing
$3,750,00019 26th AveIsle of Palms SC 29451View Listing
$3,695,0003502 Waterway BlvdIsle of Palms SC 29451View Listing
$3,600,000913 Carolina BlvdIsle Of Palms SC 29451View Listing
$3,500,0002303 Cameron BlvdIsle of Palms SC 29451View Listing
$3,398,0003407 Palm BlvdIsle of Palms SC 29451View Listing
$3,320,0002704 Cameron BlvdIsle of Palms SC 29451View Listing
$3,300,0002607 Cameron BlvdIsle of Palms SC 29451View Listing
$3,000,000314 Palm BlvdIsle of Palms SC 29451View Listing
$2,950,0003204 Waterway BlvdIsle of Palms SC 29451View Listing
$2,900,000306 Charleston BlvdIsle of Palms SC 29451View Listing
$2,900,000209 Charleston BlvdIsle of Palms SC 29451View Listing
$2,750,00024 26th AveIsle of Palms SC 29451View Listing
$2,650,0002504 Hartnett BlvdIsle of Palms SC 29451View Listing
$2,465,00010 Seagrass LnIsle of Palms SC 29451View Listing
$2,350,0004 53rd AveIsle of Palms SC 29451View Listing
$2,299,0003 Summer Dunes LnIsle of Palms SC 29451View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-09-2024 2:16:06 pm.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "SC" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 30
Blah
Ranch
Single Family
